J. Craig Williams — Smartsheet Community

Skip to content

Overview

Overview
Email	jcwill23@gmail.com
Roles	Member
Badges	35

About Me

About Me
Area of Expertise
About Me	Smartsheet Certified User <br /><br />See:<br />https://ronin-global.com/contact-us-smartsheet-help/<br />to see info about me or how to contact me.<br />The password is "thankyou"<br /><br />Also I have posted tips and tricks for Smartsheet here:<br />https://ronin-global.com/category/smartsheet-help/
How I Use Smartsheet	Daily tasks, any around the house or longer than a few days projects, project management, resource management.
Linkedin	http://www.linkedin.com/in/jcwill23
Twitter Page

Analytics

4,105

Posts

53

Visits

23.8k

Points

Nov 21, 2015

Join Date

Feb 21, 2025

Last Active

Re: Images in Dropdown list

J. Craig Williams

01/28/16

Jamie, Not yet, that I have found. http://help.smartsheet.com/customer/portal/articles/2262003 There is API functionality that could do that. Sorry to be the messenger. Craig

1 ·
Re: Is there a way to re-designate the primary column after a Smartsheet has been developed and populate

J. Craig Williams

01/05/17

There is no direct way to reassign the Primary Column. You'll need to: 1. create a tempoary column 2. copy/paste the data from Primary Column to the new column. 3. copy/paste the data from the column…

1 ·
Re: SUMIF with check mark

J. Craig Williams

02/02/17

=SUMIF([Have we paid for this container?]1:[Have we paid for this container?]100,1,[Cost]1:[Cost]100) =SUMIF(RANGE , CRITERIA , SUM_RANGE) You had )( instead of a comma. Craig

1 ·
Re: Formula to calculate the Monday after a date

J. Craig Williams

08/20/18

Project Plan? Are you using Dependencies? This formula returns the "NEXT Monday": =IF(WEEKDAY(Date@row) = 1, Date@row - (WEEKDAY(Date@row) - 2), Date@row - (WEEKDAY(Date@row) - 2) + 7) incl…

1 ·
Re: Parent Sum IF

J. Craig Williams

02/06/18

You don't use PARENT in this case. Column names with spaces (or special characters) need square brackets [] =SUMIFS([Resource Days]:[Resource Days], [Assigned To]:[Assigned To], "Craig Williams&…

1 ·